package cn.cvs.entity;

/**
 * 用户表
 */
public class Auctionuser {
    private int userId;             //用户编号
    private String userName;        //用户名
    private String userPassword;    //用户密码
    private String userCardNo;      //用户身份证号
    private String userTel;         //用户电话
    private String userAddress;     //用户地址
    private String userPostNumber;  //用户邮政编号
    private int userIsAdmin;        //用户是否是管理员，0是竞拍者，1是管理员，默认值是0'
    private String userQuestion;    //用户找回密码的问题
    private String userAnswer;      //用户找回密码答案

    @Override
    public String toString() {
        return "Auctionuser{" +
                "userId=" + userId +
                ", userName='" + userName + '\'' +
                ", userPassword='" + userPassword + '\'' +
                ", userCardNo='" + userCardNo + '\'' +
                ", userTel='" + userTel + '\'' +
                ", userAddress='" + userAddress + '\'' +
                ", userPostNumber='" + userPostNumber + '\'' +
                ", userIsAdmin=" + userIsAdmin +
                ", userQuestion='" + userQuestion + '\'' +
                ", userAnswer='" + userAnswer + '\'' +
                '}';
    }

    public Auctionuser(int userId, String userName, String userPassword, String userCardNo, String userTel, String userAddress, String userPostNumber, int userIsAdmin, String userQuestion, String userAnswer) {
        this.userId = userId;
        this.userName = userName;
        this.userPassword = userPassword;
        this.userCardNo = userCardNo;
        this.userTel = userTel;
        this.userAddress = userAddress;
        this.userPostNumber = userPostNumber;
        this.userIsAdmin = userIsAdmin;
        this.userQuestion = userQuestion;
        this.userAnswer = userAnswer;
    }

    public Auctionuser() {
    }

    public int getUserId() {
        return userId;
    }

    public void setUserId(int userId) {
        this.userId = userId;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getUserPassword() {
        return userPassword;
    }

    public void setUserPassword(String userPassword) {
        this.userPassword = userPassword;
    }

    public String getUserCardNo() {
        return userCardNo;
    }

    public void setUserCardNo(String userCardNo) {
        this.userCardNo = userCardNo;
    }

    public String getUserTel() {
        return userTel;
    }

    public void setUserTel(String userTel) {
        this.userTel = userTel;
    }

    public String getUserAddress() {
        return userAddress;
    }

    public void setUserAddress(String userAddress) {
        this.userAddress = userAddress;
    }

    public String getUserPostNumber() {
        return userPostNumber;
    }

    public void setUserPostNumber(String userPostNumber) {
        this.userPostNumber = userPostNumber;
    }

    public int getUserIsAdmin() {
        return userIsAdmin;
    }

    public void setUserIsAdmin(int userIsAdmin) {
        this.userIsAdmin = userIsAdmin;
    }

    public String getUserQuestion() {
        return userQuestion;
    }

    public void setUserQuestion(String userQuestion) {
        this.userQuestion = userQuestion;
    }

    public String getUserAnswer() {
        return userAnswer;
    }

    public void setUserAnswer(String userAnswer) {
        this.userAnswer = userAnswer;
    }
}
/*

    CREATE TABLE `auctionuser` (
        `userId` BIGINT(11) NOT NULL AUTO_INCREMENT COMMENT '用户编号',
        `userName` VARCHAR(40) NOT NULL COMMENT '用户名',
        `userPassword` VARCHAR(20) NOT NULL COMMENT '用户密码',
        `userCardNo` VARCHAR(20) DEFAULT NULL COMMENT '用户身份证号',
        `userTel` VARCHAR(20) DEFAULT NULL COMMENT '用户电话',
        `userAddress` VARCHAR(400) DEFAULT NULL COMMENT '用户地址',
        `userPostNumber` VARCHAR(6) DEFAULT NULL COMMENT '用户邮政编号',
        `userIsAdmin` BIT(1) DEFAULT b'0' COMMENT '用户是否是管理员，0是竞拍者，1是管理员，默认值是0',
        `userQuestion` VARCHAR(200) DEFAULT NULL COMMENT '用户找回密码的问题',
        `userAnswer` VARCHAR(200) DEFAULT NULL COMMENT '用户找回密码答案',
        PRIMARY KEY (`userId`),
        UNIQUE KEY `userName` (`userName`)
        ) ENGINE=INNODB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COMMENT='用户表';
*/

